ActiveReports 11 Server Designer User Guide
Formatting Numbers in Charts and Tables
ActiveReports 11 Server Designer User Guide > Working with Text and Numbers > Formatting Numbers in Charts and Tables

When working with charts and tables, you can control the formatting of dates and numbers.

With charts, you can additionally control the minimum, maximum, and steps in the scale, and whether to use a logarithmic scale. For more information, please see Axis and Scale Labels Formatting.

To format numbers in a chart or table

  1. Click to select the numbers that you want to format. The Format section of the Design toolbar is enabled.
  2. In the Design toolbar, you can click Increase Decimal or Decrease Decimal to change the number of zeros shown after the decimal point.
  3. Drop down the box at the top of the Format section of the toolbar to select from common numeric formats (or common date formats if your value is a date), or select Other to create a custom format.

Custom formats that you may find useful

Use this format string To display this number This way
0,000,000.00 1234.56 0,001,234.56
#,###,###.00 1234.56 1,234.56
#, 100,000 100
???.??? 1234.56
12.34
.123
(decimal points aligned)
Use this format string To display this date part This way
M month January 12
MM month 01-12
MMM month Jan-Dec
MMMM month January-December
d day 1-31
dd day 01-31
ddd day Sun-Sat
dddd day Sunday-Saturday
yy year 00-99
yyyy year 1900-9999